# mysql --user=root -p 
Enter password: xxxx

# mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| test               |
| zm                 |
+--------------------+
4 rows in set (0.00 sec)

#mysql> drop database zm;
Query OK, 16 rows affected (0.01 sec)

# mysql> create database zm;
Query OK, 1 row affected (0.00 sec)
# quit;
Bye
# mysql --user=root -p zm < /usr/share/zoneminder/db/zm_create.sql
# mysql --user=root -p zm

# mysql> grant select,insert,update,delete,create on zm.* to 'zmuser'@localhost identified by 'zmpass';
Query OK, 0 rows affected (0.00 sec)
# mysql> quit;
Bye
# mysqladmin --user=root -p reload